Tabela InsuranceDocument

Definicja tabeli InsuranceDocument

Name

InsuranceDocument

Code

InsuranceDocument

Comment

 


Lista kolumn tabeli InsuranceDocument

Name

Code

InsuranceDocumentID

InsuranceDocumentID

InsuranceID

InsuranceID

DocumentName

DocumentName

DocumentNo

DocumentNo

NPWZ

NPWZ

DocumentDate

DocumentDate

StartDT

StartDT

StopDT

StopDT

IssuingAuthority

IssuingAuthority

DocumentType

DocumentType

InsuranceBase

InsuranceBase

PaymentDate

PaymentDate

DocumentYear

DocumentYear

DocumentMonth

DocumentMonth

Pesel

Pesel

NIP

NIP

DeclaringPersonType

DeclaringPersonType


Kolumna InsuranceDocumentID tabeli InsuranceDocument

Definicja kolumny InsuranceDocumentID tabeli InsuranceDocument

Name

InsuranceDocumentID

Code

InsuranceDocumentID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InsuranceID tabeli InsuranceDocument

Definicja kolumny InsuranceID tabeli InsuranceDocument

Name

InsuranceID

Code

InsuranceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DocumentName tabeli InsuranceDocument

Definicja kolumny DocumentName tabeli InsuranceDocument

Name

DocumentName

Code

DocumentName

Data Type

VARCHAR2(100)

Mandatory

No

Comment

 


Kolumna DocumentNo tabeli InsuranceDocument

Definicja kolumny DocumentNo tabeli InsuranceDocument

Name

DocumentNo

Code

DocumentNo

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna NPWZ tabeli InsuranceDocument

Definicja kolumny NPWZ tabeli InsuranceDocument

Name

NPWZ

Code

NPWZ

Data Type

VARCHAR2(8)

Mandatory

No

Comment

 


Kolumna DocumentDate tabeli InsuranceDocument

Definicja kolumny DocumentDate tabeli InsuranceDocument

Name

DocumentDate

Code

DocumentDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna StartDT tabeli InsuranceDocument

Definicja kolumny StartDT tabeli InsuranceDocument

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna StopDT tabeli InsuranceDocument

Definicja kolumny StopDT tabeli InsuranceDocument

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna IssuingAuthority tabeli InsuranceDocument

Definicja kolumny IssuingAuthority tabeli InsuranceDocument

Name

IssuingAuthority

Code

IssuingAuthority

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna DocumentType tabeli InsuranceDocument

Definicja kolumny DocumentType tabeli InsuranceDocument

Name

DocumentType

Code

DocumentType

Data Type

VARCHAR2(4)

Mandatory

No

Comment

Typ dokumentu


Kolumna InsuranceBase tabeli InsuranceDocument

Definicja kolumny InsuranceBase tabeli InsuranceDocument

Name

InsuranceBase

Code

InsuranceBase

Data Type

VARCHAR2(2)

Mandatory

No

Comment

Podstawa uprawnien do swiadczen


Kolumna PaymentDate tabeli InsuranceDocument

Definicja kolumny PaymentDate tabeli InsuranceDocument

Name

PaymentDate

Code

PaymentDate

Data Type

DATE

Mandatory

No

Comment

Data oplacenia skladki


Kolumna DocumentYear tabeli InsuranceDocument

Definicja kolumny DocumentYear tabeli InsuranceDocument

Name

DocumentYear

Code

DocumentYear

Data Type

NUMBER(10)

Mandatory

No

Comment

Rok waznosci dokumentu


Kolumna DocumentMonth tabeli InsuranceDocument

Definicja kolumny DocumentMonth tabeli InsuranceDocument

Name

DocumentMonth

Code

DocumentMonth

Data Type

NUMBER(10)

Mandatory

No

Comment

Miesiac waznosci dokumentu


Kolumna Pesel tabeli InsuranceDocument

Definicja kolumny Pesel tabeli InsuranceDocument

Name

Pesel

Code

Pesel

Data Type

VARCHAR2(11)

Mandatory

No

Comment

Numer PESEL podmiotu wystawiajacego dokument


Kolumna NIP tabeli InsuranceDocument

Definicja kolumny NIP tabeli InsuranceDocument

Name

NIP

Code

NIP

Data Type

VARCHAR2(10)

Mandatory

No

Comment

Numer identyfikacji podatkowej platnika


Kolumna DeclaringPersonType tabeli InsuranceDocument

Definicja kolumny DeclaringPersonType tabeli InsuranceDocument

Name

DeclaringPersonType

Code

DeclaringPersonType

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli InsuranceDocument

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli InsuranceDocument

Definicja klucza Identifier_1 tabeli InsuranceDocument

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment